CS07 - Introduction to Database Management System

  • Bangalore Central Campus
  • Open From :
  • Open Until :

CS07 Introduction to Database Management System

Theory:  45 hours

Prerequisite: Basic knowledge of Computer

Unit 1

Data, Database, Database management system(DBMS), Characteristics of the database approach, Role of Database administrators, Role of Database Designers, End Users,  Types of DBMS, Applications of  DBMS,  Advantages of Using a DBMS and When not to use a DBMS .

(7 Hours)

Unit 2

Data Models – Categories of data models, Schemas, Instances, and Database state.  DBMS Architecture and Data Independence – The Three schema architecture, Data independence.  DBMS Languages and Interfaces.

(7 Hours)

Unit 3

Using High Level Conceptual Data Models for Database Design, Example Database applications.  Entity types, Entity Sets, Attributes and Keys.  Relationships, Relationship types, Weak Entity Types and Drawing E-R Diagrams.     

(7 Hours)     

Unit 4

Relation, Integrity constraints - domain, entity and Referential integrity constraints, Basic Relational Algebra operations, select, project and join operations. Functional dependencies and Normalization for Relational Databases - Normalization concepts, first, second, third normal forms, Boyce-Codd normal form.                        

(9 hours)

Unit 5

Queries, sub queries, correlated sub query, views, updation of a database through views, Update, Delete. Hands on Experience.                                                           

(15 hours)

Text Book:

1.      Elmasri & Navathe,  Fundamentals of Database Systems,2nd Edition, Addison – Wesley

Reference books :

1.      O`neil Patric & O`neil Elizabeth, Database Principles, Programming and Performance, 2nd Edition, Margon Kaufmann Publishers Inc.

2.      Silberschatz, Korth, Sudarshan, “Database System Concepts”, 4th Edition, Mc Graw Hill

For any queries at any given time during the application and admission process, you may contact us through the following Email ID’s:
 
Bangalore Central Campus
The Office of Admissions,
CHRIST (Deemed to be University), Hosur Road,
Bengaluru - 560 029, Karnataka, INDIA
Ph. No: +91 92430 80800
Ph. No:  +91 80 4012 9400
 
Email IDs
Indian candidates: admissions@christuniversity.in
Bangalore Bannerghatta Road Campus
CHRIST (Deemed to be University)
Hulimavu, Bannerghatta Road,
Bengaluru - 560 076, Karnataka, INDIA
 
Ph. No:  080 4655 1306
Email:
 admissions.bgr@christuniversity.in
Bangalore Kengeri Campus
CHRIST (Deemed to be University)
Kanmanike, Kumbalgodu, Mysore Road,
Bengaluru - 560 074, Karnataka, INDIA

Ph. No:  +91 80 4012 9800, 9802, 9820
Email:
 admissions.kengeri@christuniversity.in
Bangalore Yeshwanthpur Campus
CHRIST (Deemed to be University)
Nagasandra, Near Tumkur Road,
Bengaluru 560 073, Karnataka, INDIA

Ph. No:  +91 97422 44407
Email: 
admissions.yeshwanthpur@christuniversity.in
Delhi NCR Campus
CHRIST (Deemed to be University),
Mariam Nagar, Meerut Road,
Delhi NCR Ghaziabad - 201003
 
Ph. No: 1800-123-3212
Pune Lavasa Campus
CHRIST (Deemed to be University),
Christ University Road, 30 Valor Court,
PO Dasve Lavasa, Mulshi, Pune - 412112, Maharashtra
 
Ph. No : 1800-123-2009,
Email:
 admission.lavasa@christuniversity.in
Between: Monday to Friday: 09:00 AM to 04:00 PM, Saturday: 09:00 AM to 12:00 PM
(Office remains closed on Sundays, Government Holidays and Any special events)


Copyright © CHRIST (Deemed to be University) 2020